﻿using System;
namespace fanli.Model
{
	/// <summary>
	/// 商城评论实体类：fanli_shopComment 。
	/// </summary>
	[Serializable]
	public class fanli_shopComment
	{
		public fanli_shopComment()
		{}

		#region Model
		private int _id; //id
		private int _shopid; //商城id
		private int _userid; //用户id
		private string _username; //用户名
		private string _title; //标题
		private string _content; //内容
		private int _score1; //评分1
		private int _score2; //评分2
		private int _score3; //评分3
		private int _score4; //评分4
		private DateTime? _pubTime; //发布时间
		private string _pubIP; //发布ip
		private int _status; //状态
		private string _ext1; //扩展1
		private string _ext2; //扩展2


        /// <summary>
		/// id
		/// </summary>
		public int id
		{
			set{ _id=value;}
			get{return _id;}
		}
        /// <summary>
		/// 商城id
		/// </summary>
		public int shopid
		{
			set{ _shopid=value;}
			get{return _shopid;}
		}
        /// <summary>
		/// 用户id
		/// </summary>
		public int userid
		{
			set{ _userid=value;}
			get{return _userid;}
		}
        /// <summary>
		/// 用户名
		/// </summary>
		public string username
		{
			set{ _username=value;}
			get{return _username;}
		}
        /// <summary>
		/// 标题
		/// </summary>
		public string title
		{
			set{ _title=value;}
			get{return _title;}
		}
        /// <summary>
		/// 内容
		/// </summary>
		public string content
		{
			set{ _content=value;}
			get{return _content;}
		}
        /// <summary>
		/// 评分1
		/// </summary>
		public int score1
		{
			set{ _score1=value;}
			get{return _score1;}
		}
        /// <summary>
		/// 评分2
		/// </summary>
		public int score2
		{
			set{ _score2=value;}
			get{return _score2;}
		}
        /// <summary>
		/// 评分3
		/// </summary>
		public int score3
		{
			set{ _score3=value;}
			get{return _score3;}
		}
        /// <summary>
		/// 评分4
		/// </summary>
		public int score4
		{
			set{ _score4=value;}
			get{return _score4;}
		}
        /// <summary>
		/// 发布时间
		/// </summary>
		public DateTime? pubTime
		{
			set{ _pubTime=value;}
			get{return _pubTime;}
		}
        /// <summary>
		/// 发布ip
		/// </summary>
		public string pubIP
		{
			set{ _pubIP=value;}
			get{return _pubIP;}
		}
        /// <summary>
		/// 状态
		/// </summary>
		public int status
		{
			set{ _status=value;}
			get{return _status;}
		}
        /// <summary>
		/// 扩展1
		/// </summary>
		public string ext1
		{
			set{ _ext1=value;}
			get{return _ext1;}
		}
        /// <summary>
		/// 扩展2
		/// </summary>
		public string ext2
		{
			set{ _ext2=value;}
			get{return _ext2;}
		}
		#endregion Model

		#region txt document
		/*
商城评论,shopComment
id,商城id,用户id,用户名,标题,内容,评分1,评分2,评分3,评分4,发布时间,发布ip,状态,扩展1,扩展2
id,shopid,userid,username,title,content,score1,score2,score3,score4,pubTime,pubIP,status,ext1,ext2
i,i,i,c100,c256,t,i,i,i,i,d,c20,i,c100,c100


--------------------------
-- 创建表[商城评论]开始: 
-- alter table  [fanli_shopComment] add
-- IF EXISTS (SELECT 1 FROM sysobjects WHERE xtype='u' AND name='fanli_shopComment') drop table fanli_shopComment
  CREATE TABLE [fanli_shopComment] (
	 [id] integer IDENTITY (1, 1) PRIMARY KEY NOT NULL ,
	 [shopid] int,
	 [userid] int,
	 [username] [varchar] (100),
	 [title] [varchar] (256),
	 [content] [text],
	 [score1] int,
	 [score2] int,
	 [score3] int,
	 [score4] int,
	 [pubTime] [datetime],
	 [pubIP] [varchar] (20),
	 [status] int,
	 [ext1] [varchar] (100),
	 [ext2] [varchar] (100)
  )

 exec sp_addextendedproperty N'MS_Description',N'商城评论 ',N'user',N'dbo',N'table',N'fanli_shopComment', NULL, NULL
 exec sp_addextendedproperty N'MS_Description',N'id',N'user',N'dbo',N'table',N'fanli_shopComment',N'column',N'id'
 exec sp_addextendedproperty N'MS_Description',N'商城id',N'user',N'dbo',N'table',N'fanli_shopComment',N'column',N'shopid'
 exec sp_addextendedproperty N'MS_Description',N'用户id',N'user',N'dbo',N'table',N'fanli_shopComment',N'column',N'userid'
 exec sp_addextendedproperty N'MS_Description',N'用户名',N'user',N'dbo',N'table',N'fanli_shopComment',N'column',N'username'
 exec sp_addextendedproperty N'MS_Description',N'标题',N'user',N'dbo',N'table',N'fanli_shopComment',N'column',N'title'
 exec sp_addextendedproperty N'MS_Description',N'内容',N'user',N'dbo',N'table',N'fanli_shopComment',N'column',N'content'
 exec sp_addextendedproperty N'MS_Description',N'评分1',N'user',N'dbo',N'table',N'fanli_shopComment',N'column',N'score1'
 exec sp_addextendedproperty N'MS_Description',N'评分2',N'user',N'dbo',N'table',N'fanli_shopComment',N'column',N'score2'
 exec sp_addextendedproperty N'MS_Description',N'评分3',N'user',N'dbo',N'table',N'fanli_shopComment',N'column',N'score3'
 exec sp_addextendedproperty N'MS_Description',N'评分4',N'user',N'dbo',N'table',N'fanli_shopComment',N'column',N'score4'
 exec sp_addextendedproperty N'MS_Description',N'发布时间',N'user',N'dbo',N'table',N'fanli_shopComment',N'column',N'pubTime'
 exec sp_addextendedproperty N'MS_Description',N'发布ip',N'user',N'dbo',N'table',N'fanli_shopComment',N'column',N'pubIP'
 exec sp_addextendedproperty N'MS_Description',N'状态',N'user',N'dbo',N'table',N'fanli_shopComment',N'column',N'status'
 exec sp_addextendedproperty N'MS_Description',N'扩展1',N'user',N'dbo',N'table',N'fanli_shopComment',N'column',N'ext1'
 exec sp_addextendedproperty N'MS_Description',N'扩展2',N'user',N'dbo',N'table',N'fanli_shopComment',N'column',N'ext2'

-- 创建表[商城评论]结束。 
--------------------------

		*/
		#endregion document
	}
}

